package com.flash.BusinessParameters.mapper;

import com.flash.BusinessParameters.entity.Plate;
import com.flash.BusinessParameters.entity.Security;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface PlateMapper {
    @Select("select * from plate")
    public List<Plate> selectPlate();
    @Delete("delete from plate where plateId = #{plateId}")
    public int deletePlate(String plateId);
    @Insert("insert into plate values(#{plateId},#{plateName},#{plateFatherId},#{plateRemark})")
    public int insertPlate(Plate plate);
    @Insert("insert into plate values(#{plateId},#{plateName},#{plateFatherId},#{plateRemark})")
    public int insertFatherPlate(Plate plate);
    @Update("update plate set plateName = #{plateName},plateFatherId = #{plateFatherId},plateRemark = #{plateRemark} where plateId=#{plateId}")
    public int updatePlate(Plate plate);
    @Select("select count(*) from plate")
    public int selectCountPlate();
}
